Date fields: Date Input / Date Output

Control how Vitalware formats dates when they are input into date fields and how dates will display when they are output (retrieved from a database):

Specify the format for dates entered into fields that have a Date data type.

Usage

This Registry entry can be assigned to users, groups and system-wide:

Key User Group Key System
Key 1 User Group Key 1 System
Key 2 user group Key 2 Setting
Key 3 Setting Key 3 Format
Key 4 Format Key 4 Date Input
Key 5 Date Input    
Value option Value option
User user Setting Format Date Input option
Group group Setting Format Date Input option
System Setting Format Date Input option

where:

option can be:
DMY Day Month Year
MDY Month Day Year
MYD Month Year Day
DYM Day Year Month
YMD Year Month Day
YDM Year Day Month

Examples

This entry is appropriate for users in the United States, where dates are entered into date fields as Month, Day, Year:

Field Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Input
Value MDY

This entry is appropriate for users in Australia, where dates are entered into date fields as Day, Month, Year:

Field Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Input
Value DMY

Specify the format in which dates will display in a field in a module when retrieved from a database. Only affects fields that have a Date data type.

Usage

This Registry entry can be assigned to users, groups and system-wide:

Key User Group System
Key 1 User Group System
Key 2 user group Setting
Key 3 Setting Setting Format
Key 4 Format Format Date Output
Key 5 Date Output Date Output  
Value format
User user Setting Format Date Output format
Group group Setting Format Date Output format
System Setting Format Date Output format

where:

format

a series of special characters recognized by the System as format characters:

Character

Description

yy

Year - displayed with two digits, e.g. 2002 will display as 02

yyyy

Year - displayed with four digits, e.g. 2002 will display as 2002

Y

Year - displayed with four digits, e.g. 2002 will display as 2002; if year is BC it will print with a preceding negative symbol, e.g. 500BC will display as -500

M

Month - values range from 1 - 12

MM

Month - two digit values range from 01 - 12

MMM

Month - the first three letters of the month are displayed, e.g. Jan, Feb, etc.

MMMM

Month - the entire word is displayed, e.g. January, February, etc.

d

Day - values range from 1 - 31

dd

Day - two digit values range from 01 - 31

ddd

Day - the first three letters of the weekday are displayed, e.g. Mon, Tue, etc.

dddd

Day - the entire day of week is displayed, e.g. Monday, Tuesday, etc.

e

Era - if the date is BC, BC will be displayed. If the date is AD, nothing will be displayed.

E

Era - either BC or AD will be displayed.

Note: The format characters can be combined to create the desired date string, separated by any other character(s).

Examples

This setting will generate a date format applicable to the United States (e.g. 07/15/2006):

Field Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Output
Value MM/dd/yyyy

This setting will generate a date format applicable to Australia (e.g. 15-07-2006):

Field Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Output
Value dd-MM-yyyy

This setting will generate a custom date format: Feb 2, 84:

Field Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Output
Value MMM d, yy